/*
 Navicat Premium Data Transfer

 Source Server         : ConexionLocal
 Source Server Type    : MySQL
 Source Server Version : 50529
 Source Host           : localhost
 Source Database       : tksols_autoclima_sot

 Target Server Type    : MySQL
 Target Server Version : 50529
 File Encoding         : utf-8

 Date: 10/09/2014 23:35:10 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `Catalogo`
-- ----------------------------
DROP TABLE IF EXISTS `Catalogo`;
CREATE TABLE `Catalogo` (
  `idCatalogo` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `descripcion` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `idUsuarioCreacion` varchar(30) DEFAULT NULL,
  `fechaCreacion` datetime DEFAULT NULL,
  `idUsuarioModifica` varchar(30) DEFAULT NULL,
  `fechaModifica` datetime DEFAULT NULL,
  PRIMARY KEY (`idCatalogo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `Catalogo`
-- ----------------------------
BEGIN;
INSERT INTO `Catalogo` VALUES ('1', 'MARCAS_VEHICULOS', 'admin', '2014-07-27 17:33:12', '', '0000-00-00 00:00:00'), ('2', 'TIPO_COMBUSTIBLE', 'admin', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00'), ('3', 'TIPO_PERSONA', 'admin', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00'), ('4', 'TIPO_COMPROBANTE_PAGO', 'admin', '2014-09-16 22:36:39', '', '0000-00-00 00:00:00');
COMMIT;

-- ----------------------------
--  Table structure for `CatalogoDetalle`
-- ----------------------------
DROP TABLE IF EXISTS `CatalogoDetalle`;
CREATE TABLE `CatalogoDetalle` (
  `idCatalogo` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `idItem` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `numOrden` int(11) DEFAULT NULL,
  `descripcion` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `idUsuarioCreacion` varchar(30) DEFAULT NULL,
  `fechaCreacion` datetime DEFAULT NULL,
  `idUsuarioModifica` varchar(30) DEFAULT NULL,
  `fechaModifica` datetime DEFAULT NULL,
  PRIMARY KEY (`idCatalogo`,`idItem`),
  CONSTRAINT `fk_catalogodetalle_catalogo` FOREIGN KEY (`idCatalogo`) REFERENCES `Catalogo` (`idCatalogo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `CatalogoDetalle`
-- ----------------------------
BEGIN;
INSERT INTO `CatalogoDetalle` VALUES ('1', '1', '1', 'HYUNDAI', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00'), ('1', '2', '2', 'KIA', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00'), ('1', '3', '3', 'TOYOTA', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00'), ('1', '4', '4', 'NISSAN', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00'), ('1', '5', '5', 'HONDA', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00'), ('1', '6', '6', 'SCANIA', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00'), ('1', '7', '7', 'PEUGEOT', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00'), ('1', '8', '8', 'FREIGTHLINER', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00'), ('2', '1', '1', 'GASOLINA', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00'), ('2', '2', '2', 'PETROLEO', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00'), ('3', '1', '1', 'PERSONA NATURAL', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00'), ('3', '2', '2', 'PERSONA JURIDICA', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00'), ('4', '1', '1', 'BOLETA', '', '2014-09-16 22:37:02', '', '0000-00-00 00:00:00'), ('4', '2', '2', 'FACTURA', '', '2014-09-16 22:37:14', '', '0000-00-00 00:00:00');
COMMIT;

-- ----------------------------
--  Table structure for `Clientes`
-- ----------------------------
DROP TABLE IF EXISTS `Clientes`;
CREATE TABLE `Clientes` (
  `idCliente` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `idTipoPersonaCatalogo` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `idTipoPersonaItem` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nombreEntidad` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ruc` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `razonSocial` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `apellidoPaterno` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `apellidoMaterno` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nombres` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dni` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `telefono` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `correo` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `idUsuarioCreacion` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fechaCreacion` datetime DEFAULT NULL,
  `idUsuarioModifica` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fechaModifica` datetime DEFAULT NULL,
  PRIMARY KEY (`idCliente`),
  KEY `idTipoPersonaCatalogo` (`idTipoPersonaCatalogo`,`idTipoPersonaItem`),
  CONSTRAINT `fk_tipoPersona` FOREIGN KEY (`idTipoPersonaCatalogo`, `idTipoPersonaItem`) REFERENCES `CatalogoDetalle` (`idCatalogo`, `idItem`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Records of `Clientes`
-- ----------------------------
BEGIN;
INSERT INTO `Clientes` VALUES ('CLI00000001', '3', '2', 'Servicios Integrales EIRL', '4546456754', 'Servicios Integrales EIRL', null, null, null, null, '6567657', 'correo@serviciosintegrales.com', 'admin', '2014-08-03 23:02:06', 'admin', '2014-08-06 23:31:25'), ('CLI00000002', '3', '1', 'Lopez Ruiz , Jaime', null, null, 'Lopez', 'Ruiz', 'Jaime', '22224346', '6546546', 'jlopez@hotmail.com', 'admin', '2014-08-03 23:08:46', 'admin', '2014-08-25 23:24:01'), ('CLI00000003', '3', '2', 'Empresa Transporte Urbano EIRL', '65465464563', 'Empresa Transporte Urbano EIRL', null, null, null, null, '5456576', 'correo@empresa.com', 'admin', '2014-08-06 22:46:46', 'admin', '2014-08-06 23:30:26'), ('CLI00000004', '3', '1', 'Rojas PÃ©rez , Jorge', null, null, 'Rojas', 'PÃ©rez', 'Jorge', '43554666', '980345332', 'jrojas@hotmail.com', 'admin', '2014-08-06 22:53:09', 'admin', '2014-08-06 23:29:30'), ('CLI00000005', '3', '1', 'Vargas NÃºÃ±ez , Roberto', null, null, 'Vargas', 'NÃºÃ±ez', 'Roberto', '43423455', '', '', 'admin', '2014-08-25 23:26:07', null, null), ('CLI00000006', '3', '2', 'Empresa Transportes SAC', '35345345631', 'Empresa Transportes SAC', null, null, null, null, '11111', '', 'admin', '2014-08-25 23:28:01', 'dacosta', '2014-09-07 20:39:09');
COMMIT;

-- ----------------------------
--  Table structure for `OrdenesTrabajo`
-- ----------------------------
DROP TABLE IF EXISTS `OrdenesTrabajo`;
CREATE TABLE `OrdenesTrabajo` (
  `idOrden` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `nroOrden` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `idComprobanteCatalogo` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `idComprobanteItem` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `nroComprobante` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `idCliente` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `idVehiculo` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `fechaServicio` datetime DEFAULT NULL,
  `kmVehiculo` decimal(12,4) DEFAULT NULL,
  `trabajosRealizados` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `observaciones` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `precioServicio` decimal(12,4) DEFAULT NULL,
  `igvServicio` decimal(12,4) DEFAULT NULL,
  `totalServicio` decimal(12,4) DEFAULT NULL,
  `idUsuarioCreacion` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `fechaCreacion` datetime DEFAULT NULL,
  `idUsuarioModifica` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `fechaModifica` datetime DEFAULT NULL,
  `anulado` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`idOrden`),
  KEY `idCliente` (`idCliente`),
  KEY `idVehiculo` (`idVehiculo`),
  CONSTRAINT `fk_ot_cliente` FOREIGN KEY (`idCliente`) REFERENCES `Clientes` (`idCliente`),
  CONSTRAINT `fk_ot_vehiculo` FOREIGN KEY (`idVehiculo`) REFERENCES `Vehiculos` (`idVehiculo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `OrdenesTrabajo`
-- ----------------------------
BEGIN;
INSERT INTO `OrdenesTrabajo` VALUES ('ORD00000001', '00000001', null, null, null, 'CLI00000003', 'VE00000003', '2014-08-22 09:34:00', '56.6560', 'Trabajos\r\n', 'Observaciones', '25.7100', null, null, 'admin', '2014-08-04 23:02:47', 'admin', '2014-08-24 14:05:52', 'S'), ('ORD00000002', '00000002', null, null, null, 'CLI00000004', 'VE00000004', '2014-08-20 08:22:00', '45.7600', 'trabajos', 'observaciones', '890.5400', null, null, 'admin', '2014-08-04 23:12:18', 'admin', '2014-08-24 14:02:13', 'S'), ('ORD00000003', '00000003', null, null, null, 'CLI00000001', 'VE00000001', '2014-08-05 23:55:58', '54.0000', 'dsafds', 'fdsfsd', '12.0000', null, null, 'admin', '2014-08-05 23:53:03', 'admin', '2014-08-07 00:23:44', 'S'), ('ORD00000004', '00000004', null, null, null, 'CLI00000006', 'VE00000005', '2014-08-22 11:33:00', '123.0000', 'FADSFDS', '', '0.0000', '0.0000', '0.0000', 'admin', '2014-08-06 22:35:05', 'dacosta', '2014-09-07 21:01:40', 'N'), ('ORD00000005', '00000005', null, null, null, 'CLI00000004', 'VE00000004', '2014-08-20 00:00:00', '0.0000', '', '', '1000.0000', null, null, 'admin', '2014-08-07 00:16:56', 'admin', '2014-08-25 23:41:09', 'S'), ('ORD00000006', '00000006', '4', '1', '121313', 'CLI00000003', 'VE00000005', '2014-08-25 10:15:00', '130.0000', 'Afinamiento s/.120\r\nLimpieza s/.50', 'Ninguna observación', '12.5400', '2.2600', '14.8000', 'admin', '2014-08-25 23:14:12', 'dacosta', '2014-09-17 23:10:28', 'N'), ('ORD00000007', '00000007', '4', '2', 'dfgdfgdf', 'CLI00000006', 'VE00000001', '2014-08-22 00:00:00', '0.0000', 'dasfds', 'fdsfsd', '44.0000', '0.0000', '0.0000', 'admin', '2014-08-31 23:16:20', 'dacosta', '2014-09-16 23:06:22', 'N'), ('ORD00000008', '00000008', null, null, null, 'CLI00000003', 'VE00000005', '2014-09-18 00:00:00', '0.0000', null, 'fdfdsfs', '124.0000', null, null, 'admin', '2014-09-04 01:15:41', null, null, 'N'), ('ORD00000009', '00000009', null, null, null, 'CLI00000003', 'VE00000006', '2014-09-26 00:00:00', '0.0000', null, 'fdsfsd', '374.2000', '67.3600', '441.5600', 'admin', '2014-09-06 18:48:12', 'admin', '2014-09-07 13:01:57', 'N'), ('ORD00000010', '00000010', null, null, null, 'CLI00000003', 'VE00000003', '2014-09-22 00:00:00', '0.0000', null, 'fdsfsdfsd', '43.0000', null, null, 'admin', '2014-09-06 23:03:22', 'admin', '2014-09-06 23:06:01', 'N'), ('ORD00000011', '00000011', null, null, null, 'CLI00000003', 'VE00000002', '2014-09-27 00:00:00', '0.0000', null, 'fdsfsdfsd', '3355.4400', '603.9800', '3959.4200', 'admin', '2014-09-07 19:46:01', null, null, 'N');
COMMIT;

-- ----------------------------
--  Table structure for `OrdenesTrabajoDetalles`
-- ----------------------------
DROP TABLE IF EXISTS `OrdenesTrabajoDetalles`;
CREATE TABLE `OrdenesTrabajoDetalles` (
  `idOrdenTrabajo` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `idOrdenTrabajoDetalle` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `descripcionTrabajo` varchar(300) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `costoTrabajo` decimal(12,4) DEFAULT NULL,
  `idUsuarioCreacion` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `fechaCreacion` datetime DEFAULT NULL,
  `idUsuarioModifica` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `fechaModifica` datetime DEFAULT NULL,
  PRIMARY KEY (`idOrdenTrabajo`,`idOrdenTrabajoDetalle`),
  CONSTRAINT `FK_OrdenTrabajoDetalle_OrdenTrabajo` FOREIGN KEY (`idOrdenTrabajo`) REFERENCES `OrdenesTrabajo` (`idOrden`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `OrdenesTrabajoDetalles`
-- ----------------------------
BEGIN;
INSERT INTO `OrdenesTrabajoDetalles` VALUES ('ORD00000006', '0002', 'Afinamiento y limpieza', '12.5400', 'admin', '2014-09-06 23:44:52', 'dacosta', '2014-09-07 20:59:50'), ('ORD00000007', '0001', 'Cambio de motor', '12.0000', 'admin', '2014-09-06 23:42:02', null, null), ('ORD00000009', '0001', 'Actualización de datos', '16.6600', 'admin', '2014-09-06 18:48:12', 'admin', '2014-09-06 23:37:35'), ('ORD00000009', '0002', 'Cambio de llantas', '12.5400', 'admin', '2014-09-06 18:48:12', 'admin', '2014-09-06 23:37:26'), ('ORD00000009', '0003', 'Cambio de aceite', '345.0000', 'admin', '2014-09-06 18:48:34', 'admin', '2014-09-07 13:01:57'), ('ORD00000010', '0001', 'Limpieza', '43.0000', 'admin', '2014-09-06 23:03:34', 'admin', '2014-09-06 23:06:01'), ('ORD00000011', '0001', 'Cambio de batería', '3343.0000', 'admin', '2014-09-07 19:46:01', null, null), ('ORD00000011', '0002', 'Mantenimiento de rutina', '12.4400', 'admin', '2014-09-07 19:46:01', null, null);
COMMIT;

-- ----------------------------
--  Table structure for `SistemaParametros`
-- ----------------------------
DROP TABLE IF EXISTS `SistemaParametros`;
CREATE TABLE `SistemaParametros` (
  `idParametro` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `descripcionParametro` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `valorParametro` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `idUsuarioCreacion` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `fechaCreacion` datetime DEFAULT NULL,
  `idUsuarioModifica` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `fechaModifica` datetime DEFAULT NULL,
  PRIMARY KEY (`idParametro`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `SistemaParametros`
-- ----------------------------
BEGIN;
INSERT INTO `SistemaParametros` VALUES ('IGV', 'Impuesto Ventas', '18', 'admin', '2014-09-06 23:13:53', null, null);
COMMIT;

-- ----------------------------
--  Table structure for `Usuarios`
-- ----------------------------
DROP TABLE IF EXISTS `Usuarios`;
CREATE TABLE `Usuarios` (
  `idUsuario` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `nombreUsuario` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `apellidosUsuario` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `claveUsuario` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `idUsuarioCreacion` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `fechaCreacion` datetime DEFAULT NULL,
  `idUsuarioModifica` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `fechaModifica` datetime DEFAULT NULL,
  PRIMARY KEY (`idUsuario`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `Usuarios`
-- ----------------------------
BEGIN;
INSERT INTO `Usuarios` VALUES ('dacosta', 'Dennis', 'Acosta', '7c4a8d09ca3762af61e59520943dc26494f8941b', 'admin', '2014-09-07 19:56:53', null, null);
COMMIT;

-- ----------------------------
--  Table structure for `Vehiculos`
-- ----------------------------
DROP TABLE IF EXISTS `Vehiculos`;
CREATE TABLE `Vehiculos` (
  `idVehiculo` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `numeroPlaca` varchar(30) DEFAULT NULL,
  `anio` varchar(4) DEFAULT NULL,
  `idMarcaCatalogo` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `idMarcaItem` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `modelo` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `color` varchar(30) DEFAULT NULL,
  `idCombustibleCatalogo` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `idCombustibleItem` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `idCliente` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `idUsuarioCreacion` varchar(30) DEFAULT NULL,
  `fechaCreacion` datetime DEFAULT NULL,
  `idUsuarioModifica` varchar(30) DEFAULT NULL,
  `fechaModifica` datetime DEFAULT NULL,
  PRIMARY KEY (`idVehiculo`),
  KEY `idCliente` (`idCliente`),
  KEY `idMarcaCatalogo` (`idMarcaCatalogo`,`idMarcaItem`),
  KEY `idCombustibleCatalogo` (`idCombustibleCatalogo`,`idCombustibleItem`),
  CONSTRAINT `fk_vehiculo_cliente` FOREIGN KEY (`idCliente`) REFERENCES `Clientes` (`idCliente`),
  CONSTRAINT `fk_vehiculo_combustible` FOREIGN KEY (`idCombustibleCatalogo`, `idCombustibleItem`) REFERENCES `CatalogoDetalle` (`idCatalogo`, `idItem`),
  CONSTRAINT `fk_vehiculo_marca` FOREIGN KEY (`idMarcaCatalogo`, `idMarcaItem`) REFERENCES `CatalogoDetalle` (`idCatalogo`, `idItem`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `Vehiculos`
-- ----------------------------
BEGIN;
INSERT INTO `Vehiculos` VALUES ('VE00000001', 'VJT-775', '2014', '1', '2', null, 'ROJO', '2', '1', 'CLI00000001', 'admin', '2014-08-03 23:11:19', 'admin', '2014-08-06 23:28:12'), ('VE00000002', 'VJU463', '2014', '1', '5', null, 'AZUL', '2', '1', 'CLI00000001', 'admin', '2014-08-06 23:31:57', 'admin', '2014-08-06 23:32:05'), ('VE00000003', 'AZJ563', '2012', '1', '7', '306', 'VERDE', '2', '2', null, 'admin', '2014-08-06 23:32:30', 'dacosta', '2014-09-07 20:41:43'), ('VE00000004', 'TDY467', '2014', '1', '4', 'TIIDA', 'PLATA', '2', '1', 'CLI00000004', 'admin', '2014-08-06 23:32:52', 'admin', '2014-08-31 22:38:42'), ('VE00000005', 'AHT-775', '2013', '1', '4', 'SENTRA', 'NEGRO', '2', '1', 'CLI00000003', 'admin', '2014-08-25 23:33:05', 'admin', '2014-08-31 22:38:02'), ('VE00000006', '65dsgd', '2010', '1', '5', 'CIVIC', 'VERDE', '2', '2', null, 'admin', '2014-08-31 23:20:24', 'admin', '2014-08-31 23:20:33'), ('VE00000007', 'YTE-656', '2012', '1', '1', 'ELANTRA', '', '2', '1', null, 'dacosta', '2014-09-07 20:58:42', null, null);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
